

*Pre-process data for maps

global root    = "/disk/bulkw/nencka/schooling_pandemic/2021_10_18_final/"
global input   "$root/Input"
global scripts "$root/Scripts"
global temp    "$root/Temp"
global output  "$root/Output"
global log     "$root/Log"
global figures "$root/Figures"
global tables "$root/Tables"

**

use "$temp/city_covariates.dta", clear


	rename mcd city
	replace city = proper(city)

	cap drop _m
	statastates, fips(statefip)
	keep if _m == 3
	drop _m 
	
sort statefip state_name city 
order statefip state_name city
gen address_to_code = city + ", " + state_name
drop if mi(days_closed)
export delimited using "$temp/cleaned_city_covars.csv", replace 	

*EOF

